﻿<%@ Page Language="C#" AutoEventWireup="true" CodeFile="YSFGLCX.aspx.cs" Inherits="YSFGL_YSFGLCX" %>

<%@ Register Assembly="DevExpress.Web.v12.1, Version=12.1.5.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a"
  Namespace="DevExpress.Web.ASPxPanel" TagPrefix="dxp" %>
<%@ Register Assembly="DevExpress.Web.v12.1, Version=12.1.5.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a"
  Namespace="DevExpress.Web.ASPxCallbackPanel" TagPrefix="dxcp" %>
<%@ Register Assembly="DevExpress.Web.v12.1, Version=12.1.5.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a"
  Namespace="DevExpress.Web.ASPxPopupControl" TagPrefix="dxpc" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<%@ Register Assembly="DevExpress.Web.ASPxEditors.v12.1, Version=12.1.5.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a"
  Namespace="DevExpress.Web.ASPxEditors" TagPrefix="dxe" %>
<%@ Register Assembly="DevExpress.Web.ASPxGridView.v12.1, Version=12.1.5.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a"
  Namespace="DevExpress.Web.ASPxGridView" TagPrefix="dxwgv" %>
<%@ Register Assembly="DevExpress.Web.ASPxGridView.v12.1.Export, Version=12.1.5.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a"
  Namespace="DevExpress.Web.ASPxGridView.Export" TagPrefix="dxwgv" %>
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
  <title>应收费查询</title>
  <style type="text/css">
    body
    {
      color: #000;
      background-color: #EEF2FB;
      margin: 0px;
      font-family: "宋体";
      font-size: 12px;
    }
  </style>
  <link href="../css/main.css" rel="stylesheet" type="text/css" />
</head>
<body>
  <form id="form1" runat="server">
  <table width="100%" border="0" cellpadding="0" cellspacing="0" bgcolor="#EEF2FB">
    <%--<tr>
      <td width="17" valign="top" background="../images/mail_leftbg.gif">
        <img src="../images/left-top-right.gif" width="17" height="29" />
      </td>
      <td valign="top" background="../images/content-bg.gif">
        <table width="100%" height="31" border="0" cellpadding="0" cellspacing="0" class="left_topbg"
          id="table2">
          <tr>
            <td height="31">
              <div class="titlebt">
                应收费管理</div>
            </td>
          </tr>
        </table>
      </td>
      <td width="16" valign="top" background="../images/mail_rightbg.gif">
        <img src="../images/nav-right-bg.gif" width="16" height="29" />
      </td>
    </tr>--%>
    <tr>
      <%-- <td valign="middle" background="../images/mail_leftbg.gif">
        &nbsp;
      </td>--%>
      <td valign="top" bgcolor="#F7F8F9">
        <div style="width: 98%;">
          <table>
            <tr>
              <td>
                <table cellpadding="0" cellspacing="0">
                  <tr>
                    <td>
                      <asp:DropDownList ID="ddlZT" runat="server">
                        <asp:ListItem Value="0">未审核</asp:ListItem>
                        <asp:ListItem Value="1">已审核</asp:ListItem>
                      </asp:DropDownList>
                      <%--  <asp:Label ID="Label1" runat="server" Text="客户编码"></asp:Label>
                      <asp:TextBox ID="txtKHBM" runat="server" Width="50px"></asp:TextBox>
                      <asp:Label ID="Label5" runat="server" Text="客户名称"></asp:Label>
                      <asp:TextBox ID="txtKHMC" runat="server" Width="50px"></asp:TextBox>
                      <asp:Label ID="Label2" runat="server" Text="标识"></asp:Label>
                      <asp:TextBox ID="txtBS" runat="server" Width="50px"></asp:TextBox>
                      <asp:Label ID="Label3" runat="server" Text="线路"></asp:Label>
                      <asp:TextBox ID="txtXL" runat="server" Width="100px"></asp:TextBox>--%>
                      <td>
                        <dxe:ASPxDateEdit ID="date1" runat="server" Width="90px">
                        </dxe:ASPxDateEdit>
                      </td>
                      <td>
                        <asp:RequiredFieldValidator ID="RequiredFieldValidator1" runat="server" ControlToValidate="date1"
                          ErrorMessage="*"></asp:RequiredFieldValidator>
                      </td>
                      <td>
                        <dxe:ASPxDateEdit ID="date2" runat="server" Width="90px">
                        </dxe:ASPxDateEdit>
                      </td>
                      <td>
                        <asp:RequiredFieldValidator ID="RequiredFieldValidator2" runat="server" ControlToValidate="date2"
                          ErrorMessage="*"></asp:RequiredFieldValidator>
                      </td>
                      <td>
                        <asp:Button ID="btnQuery" runat="server" Text="查询" OnClick="btnQuery_Click" />
                        <dxwgv:ASPxGridViewExporter ID="ASPxGridViewExporter1" runat="server" GridViewID="ASPxGridView1">
                        </dxwgv:ASPxGridViewExporter>
                        <asp:Button ID="Button1" runat="server" Text="导出excel" OnClick="btnExport_Click" />
                      </td>
                    </td>
                  </tr>
                </table>
              </td>
            </tr>
            <%-- <tr>
              <td>
                <table cellpadding="0" cellspacing="0">
                  <tr>
                  <td>
                      <asp:RangeValidator ID="RangeValidator1" runat="server" ErrorMessage="客户编码必须为数字" ControlToValidate="txtKHBM"
                        MaximumValue="1000000000" MinimumValue="0" Type="Integer"></asp:RangeValidator>
                    </td>
                  </tr>
                </table>
              </td>
            </tr>--%>
          </table>
        </div>
        <div style="width: 98%;">
          <dxpc:ASPxPopupControl ID="popup" ClientInstanceName="popup" runat="server" AllowDragging="true"
            PopupHorizontalAlign="OutsideRight" HeaderText="备注">
            <ContentCollection>
              <dxpc:PopupControlContentControl ID="PopupControlContentControl1" runat="server">
                <dxcp:ASPxCallbackPanel ID="cpPopup" ClientInstanceName="cpPopup" runat="server"
                  Width="320px" OnCallback="cpPopup_Callback">
                  <PanelCollection>
                    <dxp:PanelContent ID="PanelContent1" runat="server">
                      <asp:Literal ID="litText" runat="server" Text=""></asp:Literal>
                    </dxp:PanelContent>
                  </PanelCollection>
                </dxcp:ASPxCallbackPanel>
              </dxpc:PopupControlContentControl>
            </ContentCollection>
          </dxpc:ASPxPopupControl>
          <dxwgv:ASPxGridView ID="ASPxGridView1" runat="server" AutoGenerateColumns="False"
            KeyFieldName="xh" Width="100%" CssFilePath="~/App_Themes/Office2003 Blue/{0}/styles.css"
            CssPostfix="Office2003_Blue" Theme="Aqua">
            <SettingsBehavior AllowFocusedRow="True" AutoFilterRowInputDelay="-1" />
            <SettingsPager Mode="ShowPager" PageSize="12">
              <FirstPageButton Text="首页" Visible="True">
              </FirstPageButton>
              <LastPageButton Text="末页" Visible="True">
              </LastPageButton>
              <Summary Text="总页数 {1} 当前页 {0} (总记录 {2})" />
            </SettingsPager>
            <Styles CssFilePath="~/App_Themes/Office2003 Blue/{0}/styles.css" CssPostfix="Office2003_Blue">
              <Header ImageSpacing="5px" SortingImageSpacing="5px">
              </Header>
              <LoadingPanel ImageSpacing="10px">
              </LoadingPanel>
            </Styles>
            <Images ImageFolder="~/App_Themes/Office2003 Blue/{0}/">
              <FilterRowButton Height="13px" Width="13px" />
              <CollapsedButton Height="12px" Url="~/App_Themes/Office2003 Blue/GridView/gvCollapsedButton.png"
                Width="11px" />
              <ExpandedButton Height="12px" Url="~/App_Themes/Office2003 Blue/GridView/gvExpandedButton.png"
                Width="11px" />
              <DetailCollapsedButton Height="12px" Url="~/App_Themes/Office2003 Blue/GridView/gvCollapsedButton.png"
                Width="11px" />
              <DetailExpandedButton Height="12px" Url="~/App_Themes/Office2003 Blue/GridView/gvExpandedButton.png"
                Width="11px" />
            </Images>
            <Columns>
              <dxwgv:GridViewDataTextColumn Caption="序号" FieldName="xh" VisibleIndex="0" Width="50px"
                FixedStyle="Left">
              </dxwgv:GridViewDataTextColumn>
              <dxwgv:GridViewDataTextColumn Caption="客户编码" FieldName="KHID" VisibleIndex="1" FixedStyle="Left"
                Width="70px">
                <Settings AutoFilterCondition="Equals" />
              </dxwgv:GridViewDataTextColumn>
              <dxwgv:GridViewDataTextColumn Caption="客户名称" FieldName="KHMC" VisibleIndex="1" FixedStyle="Left"
                Width="200px">
                <Settings AutoFilterCondition="Contains" />
              </dxwgv:GridViewDataTextColumn>
              <dxwgv:GridViewDataTextColumn Caption="标识" FieldName="KH" FixedStyle="Left" VisibleIndex="1"
                Width="100px">
              </dxwgv:GridViewDataTextColumn>
              <dxwgv:GridViewDataTextColumn Caption="IC卡户" FieldName="IC" VisibleIndex="1" Width="55px">
              </dxwgv:GridViewDataTextColumn>
              <dxwgv:GridViewDataTextColumn Caption="线路" FieldName="KHXX_SFSB" VisibleIndex="1">
              </dxwgv:GridViewDataTextColumn>
              <dxwgv:GridViewDataTextColumn Caption="用气地址" FieldName="XXDZ" VisibleIndex="1" Width="250px">
              </dxwgv:GridViewDataTextColumn>
              <dxwgv:GridViewDataTextColumn Caption="录入人员" FieldName="XM" VisibleIndex="1">
              </dxwgv:GridViewDataTextColumn>
              <dxwgv:GridViewDataTextColumn Caption="录入时间" FieldName="BYCBSJ" VisibleIndex="1">
              </dxwgv:GridViewDataTextColumn>
              <dxwgv:GridViewDataTextColumn Caption="审核人员" FieldName="SHRXM" VisibleIndex="1">
              </dxwgv:GridViewDataTextColumn>
              <dxwgv:GridViewDataTextColumn Caption="审核时间" FieldName="SHSJ" VisibleIndex="1">
              </dxwgv:GridViewDataTextColumn>
              <dxwgv:GridViewDataTextColumn Caption="用气性质" FieldName="YQXZ" VisibleIndex="1">
              </dxwgv:GridViewDataTextColumn>
              <dxwgv:GridViewDataTextColumn Caption="单价<br>(元)" FieldName="JG" VisibleIndex="1">
              </dxwgv:GridViewDataTextColumn>
              <dxwgv:GridViewDataTextColumn Caption="价格调节<br>基金(元)" FieldName="JJ" VisibleIndex="1">
              </dxwgv:GridViewDataTextColumn>
              <dxwgv:GridViewDataTextColumn Caption="本期气量(m<sup>3</sup>)" FieldName="BQQL" VisibleIndex="1">
                <DataItemTemplate>
                  <asp:Label ID="Label3" runat="server" Text='<%#Eval("BQQL").ToString()==""?"":string.Format("{0:n}", Convert.ToDecimal(Eval("BQQL"))) %>'></asp:Label>
                </DataItemTemplate>
              </dxwgv:GridViewDataTextColumn>
              <dxwgv:GridViewDataTextColumn Caption="收入(含税)(m<sup>3</sup>)" FieldName="SR" VisibleIndex="1">
                <DataItemTemplate>
                  <asp:Label ID="Label3" runat="server" Text='<%#Eval("SR").ToString()==""?"":string.Format("{0:n}", Convert.ToDecimal(Eval("SR"))) %>'></asp:Label>
                </DataItemTemplate>
              </dxwgv:GridViewDataTextColumn>
              <dxwgv:GridViewDataTextColumn Caption="价格基金<br>(元)" FieldName="JGJJ" VisibleIndex="1">
                <DataItemTemplate>
                  <asp:Label ID="Label3" runat="server" Text='<%#Eval("JGJJ").ToString()==""?"":string.Format("{0:n}", Convert.ToDecimal(Eval("JGJJ"))) %>'></asp:Label>
                </DataItemTemplate>
              </dxwgv:GridViewDataTextColumn>
              <dxwgv:GridViewDataTextColumn Caption="本期应收金额(元)" FieldName="BQFY" VisibleIndex="1">
                <DataItemTemplate>
                  <asp:Label ID="Label3" runat="server" Text='<%#Eval("BQFY").ToString()==""?"":string.Format("{0:n}", Convert.ToDecimal(Eval("BQFY"))) %>'></asp:Label>
                </DataItemTemplate>
              </dxwgv:GridViewDataTextColumn>
              <dxwgv:GridViewDataColumn Caption="备注" VisibleIndex="1" Width="60px">
                <DataItemTemplate>
                  <a href="javascript:void(0);" onclick="OnMoreInfoClick(this, '<%#Eval("cbsjid") %>')">
                    <%#Eval("cbbz").ToString().Equals("")?"&nbsp;":Eval("cbbz").ToString().Substring(0,1)+"..." %></a>
                </DataItemTemplate>
              </dxwgv:GridViewDataColumn>
            </Columns>
            <Settings ShowHorizontalScrollBar="True" UseFixedTableLayout="True" ShowFilterRow="true"
              ShowFilterRowMenu="true" ShowFooter="true" />
            <StylesEditors>
              <ProgressBar Height="25px">
              </ProgressBar>
            </StylesEditors>
            <TotalSummary>
              <dxwgv:ASPxSummaryItem FieldName="xh" SummaryType="Count" DisplayFormat="合计" />
              <dxwgv:ASPxSummaryItem FieldName="KHMC" SummaryType="Count" DisplayFormat="客户数量:{0}" />
              <dxwgv:ASPxSummaryItem FieldName="BQQL" SummaryType="Sum" DisplayFormat="{0:n}" />
              <dxwgv:ASPxSummaryItem FieldName="BQFY" SummaryType="Sum" DisplayFormat="{0:n}" />
            </TotalSummary>
          </dxwgv:ASPxGridView>
        </div>
      </td>
      <%--   <td background="../images/mail_rightbg.gif">
        &nbsp;
      </td>--%>
    </tr>
    <%-- <tr>
      <td valign="bottom" background="../images/mail_leftbg.gif">
        <img src="../images/buttom_left2.gif" width="17" height="17" />
      </td>
      <td background="../images/buttom_bgs.gif">
        <img src="../images/buttom_bgs.gif" width="17" height="17">
      </td>
      <td valign="bottom" background="../images/mail_rightbg.gif">
        <img src="../images/buttom_right2.gif" width="16" height="17" />
      </td>
    </tr>--%>
  </table>
  </form>
</body>
<script type="text/javascript" language="javascript">
  function OnMoreInfoClick(element, keyValue) {
    popup.ShowAtElement(element);
    cpPopup.PerformCallback(keyValue);
  }
</script>
</html>
